select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Best Ball Gown Sweetheart Ruffled Quinceanera Gown Dresses
Noble Gold Ball Gown Quinces Dresses with Sash and Embroidery
Ball Gown Embroidery Ruffled Light Purple Sweet Sixteen Dresses
2012 Hot Sale Ball Gown Embroidery White Quinceanera Dresses
Plus Size Simple Ball Gown White Sweet 15 Dresses with Red Hem
Dreamy Scoop Ball Gown Appliqued White Dresses for Sweet 16
Wine Red Ball Gown Strapless Beading Embroidery Dresses for 15
Fuchsia Ball Gown Strapless Appliques Sweet 15 Dresses
New Watermelon Ball Gown Sweetheart Beading Quince Dresses
New Puffy Orange Red Strapless Embroidery Dress for Sweet 15
Colorful Zebra Ruffled Quinceanera Dresses with Spaghetti Straps
Brown Strapless Embroidery Beaded Pick-ups Sweet 15 Dresses
Most Popular Colorful Sweetheart Lace up Back Sweet 15 Dresses
Hand Made Flowers with Embroidery Strapless Dress for Sweet 15
Fuchsia Embroidery Strapless Quinceanera Gown with Pick-ups
New Colorful Strapless Appliques and Ruffles Sweet 15 Dresses
New Blue Sweetheart Beaded Ruffles Decorate Sweet 15 Dresses
Pink and White Embroidery Strapless Quince Dresses with Bow
Popular Fuchsia Long Sleeves Appliques Dress for Sweet 15
Best Puffy Pink Strapless Dress for Sweet 15 with Flora Appliques
Hot Pink Strapless Pick-ups and Pleats Beading Quinceanera Dresses
Watermelon Red Sweetheart Ruffles Accent Beaded Sweet 15 Dresses
Pink and Black Sweetheart Tiered Beaded Dress for Quince
Most Popular Watermelon and White Strapless Ruffles Quince Dress
Colorful off the Shoulder Pick-ups Lace Decorate Sweet 15 Dresses
One Shoulder Ruched Bodice Embroidery Pick-ups Dress for Quince
Sweetheart Ball Gown Beading Pleats Decorate Sweet 15 Dresses
New Arrival Lilac Strapless Beading Ball Gown Dresses for 15
New Style Apple Green Sweetheart Beading Appliques Quince Dresses
A-line Sweetheart Appliques and Beading S Weet 15 Dresses